use rated
go

-- Add support for user's first/last name
alter table UserProfile add FirstName nvarchar(100), LastName nvarchar(100)
-- Add support for user's Title
alter table UserProfile add Title nvarchar(100)
-- Add support for user's Location
alter table UserProfile add ContinentID int foreign key references Continent(ID)
alter table UserProfile add CountryID int foreign key references Country(ID)
alter table UserProfile add LocalityID int foreign key references Locality(ID)
alter table UserProfile add StateID int foreign key references [State](ID)
alter table UserProfile add CityID int foreign key references City(ID)

-- For UI display
alter table RatedItemType add RankText varchar(50)
go

-- Add support for RatedItem's Location
alter table RatedItem add ContinentID int foreign key references Continent(ID)
alter table RatedItem add CountryID int foreign key references Country(ID)
alter table RatedItem add LocalityID int foreign key references Locality(ID)
alter table RatedItem add StateID int foreign key references [State](ID)
alter table RatedItem add CityID int foreign key references City(ID)
